ABSTRACT
Benue State University Library management system is a project which aims in developing an online system to maintain all the daily work of the library. This project has many features which are generally not available in normal library management systems like facility of user login and a facility of teachers’ login. It also has a facility of admin login through which the administrator can monitor the whole system. It also has facility of an online notice board where teachers and students can put up information about workshops or seminars being held in their colleges or nearby colleges and librarian after proper verification from the concerned department organizing the seminar can add it to the notice board. It has also a facility where student after logging in their accounts can see list of books issued and its issue date and return date and also the students can request the librarian to add new books by filling the book request form. The librarian after logging into his account i.e admin account can generate various reports such as student report, issue report, teacher report and book report. Overall this project is being developed to help the students as well as staff of Benue State University, Makurdi library to maintain the library in the best way possible and also reduce the human efforts.
TABLE OF CONTENTS
Cover page…………………………………………………………………………..i
Declaration ………………………………………………………………………..ii
Certification ………………………………………………………………….……iii
Dedication …………………………………………………………………….…...iv
Acknowledgement …………………………………………………………………v
Abstract ……………………………………………………………………………vi
Table of content ………………………………………………………………...vii
Chapter one ………………………………………………………...........................1
1.0 Introduction ………………………………………………………………….1
1.1 Background of the study ……………………………………….........................1
1.2 Statement of the problem ……………………………………………..………..4
1.3 Aim and objectives of the study …………………………………………..…4
1.4 Purpose of the study …………………………………………...........................5
1.5 Scope of the project ………………………………………………………….5
1.6 Definition of terms ……………………………………………………………..5
Chapter two ………………………………………………………...........................7
2.0 Introduction ……………………………………………………………………7
2.1 Development of a library management system ……………………………...9
2.2 Features of a library management ………………………………………..…11
2.3 Need for library management ………………………………………………...13
2.4 Library management system initiative worldwide ……………………….…13
2.5 Review of problems and challenges of library professionals in
developing countries……………………………………………………...….18
2.6 Library automation and computerization ………………………………..…21
2.7 Challenges of computerization ……………………………………………..22
2.7.1 WAN/LAN …………………………………………………………….…22
2.7.2 computer literacy/education ……………………………………………...23
2.7.3 Poor state of power generation……………………………………………23
2.7.4 Poor maintenance and update culture …………………………………….23
2.7.5 Getting used to ALICE ……………………………………………...……24
2.7.6 Poor funding of library services …………………………………………..24
2.7.7 Education and training…………………………………………………….24
2.8 System analysis …………………………………………………………...…..25
2.8.1 Software requirement and specification ………………………………..…..26
2.8.2 General description ……………………………………………………….26
2.9 Systems objectives ……………………………………………………...…….26
2.10 Development of library management system ……………………………..26
2.11 System requirements ………………………………………………………...28
2.11.1 Non functional requirements …………………………………………....28
2.11.2 Organizational requirements ………………………………………...…….30
2.11.3 Implementation requirements ……………………………………....…...30
2.11.4 Functional requirements ……………………………………………..….30
2.11.5 Software and hardware requirements ……………………………….…..30
2.12 Existing proposed system ………………………………………………....31
2.13 Software Tools used ………………………………………………………32
Chapter three ……………………………………………………………………...37
3.0 System analysis and design ………………………………………………....37
3.1 Introduction …………………………………….………………………...…37
3.2 Information gathering ……………………………………………………..….37
3.3 Analysis of existing system ………………………………………….….….38
3.3.1 Problems of existing system ………………………………………….…….38
3.3.2 Description of proposed system ……………………………………………38
3.3.3 Advantages of proposed system ……………………………………………39
3.4 Design and implementation methodology ………………………………….39
3.4.1 Software requirement ………………………………………………...…..39
3.4.2 Software tools used ……………………………………………………….39
3.4.3 Hardware requirement …………………………………………………....42
3.5 System development approach……………………………………………...43
3.5.1Model …………………………………………………………………….…44
3.5.2 Requirement analysis and system design ………………………………...45
3.5.3 Architectural design ……………………………………………………..….46
3.5.4 Model design …………………………………………………………..…46
3.5.5 Validation phases ………………………………………………………..….47
3.6 Table design …………………………………………………………………..48
3.7 Data flow Diagrams …………………………………………………………..52
Chapter four ……………………………………………………………………....57
4.0 System implementation and documentation ……………………………….....57
4.1 Implementation of the system………………………………………………....57
4.2 Admin database ………………………………………………………..…...57
4.2.1 Hardware support …………………………………………………….......57
4.2.2 Software support ………………………………………………………..…..57
4.2.3 Documentation of the system …………………………………………..….58
4.2.3.1 Program documentation …………………………………………………..58
4.2.3.2 Procedure design ……………………………………………………….....58
4.2.3.4 Operating system ……………………………………………………….59
4.3 Module description…………………………………………………………....59
4.3.1 Code for admin module……………………………………………………..59
4.3.2 Code for entering admin username and password ………………………....59
4.3.3 Code for checking of admin username and password information ………..68
4.4 Code for student validation …………………………………………………..69
4.5 Code for teacher registration …………………………………………………72
4.6 Code for book addition ……………………………………………………….73
4.7 Student module …………………………………………………………….…74
4.7.1 Code for student account creation ………………………………………..74
4.7.2 Code for student login check ……………………………………………...91
4.8 Code for event addition……………………………………………………104
4.9 Teacher Module ……………………………………………………………..105
4.9.1 Code for teacher login …………………………………………………..105
4.10 Code for suggestions……………………………………………………..107
4.11 Code for adding new books …………………………………………...…119
4.12 Code for book search ………………………………………………….....121
4.13 Code for issue book ……………………………………………………...133
4.14 Code for book return ………………………………………………………135
4.15 Code for report generation …………………………………………………136
4.15.1 Code for teacher report…………………………………………………131
4.15.2 Code for student report ……………………………………………...…132
4.15.3 Code for issue report …………………………………………………..…138
4.15.4 Code for book report ………………………………………………..….139
4.16 Output and input design ……………………………………………….…140
4.17 System testing ……………………………………………………………150
4.17.1 Unit testing ………………………………………………………….....150
4.18 Integration testing ………………………………………………………..151
Chapter five ………………………………………………………………...…152
5.0 Conclusion and recommendation ……………………………………...….152
5.1 Conclusion ……………………………………………………………..……152
5.2 Recommendation ………………………………………………………...….152
References ……………………………………………….………………….....153
List of tables
Table1. Operation environment ……………………………………………………3
Table 2. Book table for keeping track of books …………………………………48
Table 3. Students information ……………………………………………….....49
Table 4. Keep teachers information ………………………………………….....50
Table 5. Keep track of book issued ……………………………………………..50
Table 6. Student Login ……………………………………….…………….......51
Table 7. Event information ……………………………………………………..51
Table 8. Teacher Login …………………………………………………………52
Figures
Figure 1. V-Model ……………………………………………………………..44
Figure 2. Data flow diagram for teacher login ………………………………….52
Figure 3. Data flow diagram for students Login ………………………………..53
Figure 4. Data flow diagram for book issue ……………………………………54
Figure 5. Data flow diagram for book search …………………………………..55
Figure 6. Data flow diagram for account creation ……………………………...56
Modules
Module 1. Admin…………………………………………………………...……..59
Module 2. Student …………………………………………………………...…....74
Module 3. Teacher …………………………………………………………….105
Module 4. Add new books …………………………………………………….119
Module 5. Book transaction ……………………………………………..………133
Module 6. Report ………………………………………………………..………136
Plates
Plate 1. Screenshot for home page …………………………………………….141
Plate 2. Screenshot for admin/User login ……………………………………...143
Plate 3. Screenshot for add book ……………………………………………...143
Plate 4. Screenshot for add user …………………………………………………145
Plate 5. Screenshot for book borrow ………………………………………….147
Plate 6. Screenshot for user table………………………………………………148
Plate 7. Screenshot for borrow details table …………………………………...149
Plate 8. Screenshot for member table …………………………………………149